const Sequelize = require('sequelize');
module.exports = function(sequelize, DataTypes) {
  return sequelize.define('zb_projectinfo', {
    ID: {
      type: DataTypes.INTEGER,
      allowNull: false,
      primaryKey: true
    },
    classID: {
      type: DataTypes.INTEGER,
      allowNull: true
    },
    zbKindClassID: {
      type: DataTypes.INTEGER,
      allowNull: true
    },
    AreaCode: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    ProjectName: {
      type: DataTypes.STRING(200),
      allowNull: true
    },
    Address: {
      type: DataTypes.STRING(200),
      allowNull: true
    },
    ProjectAreas: {
      type: DataTypes.STRING(200),
      allowNull: true
    },
    ProjectAreasFlag: {
      type: DataTypes.SMALLINT,
      allowNull: true
    },
    PlanCost: {
      type: DataTypes.STRING(100),
      allowNull: true
    },
    InvestSum: {
      type: DataTypes.STRING(100),
      allowNull: true
    },
    InvestSumSource: {
      type: DataTypes.STRING(100),
      allowNull: true
    },
    StructKind: {
      type: DataTypes.INTEGER,
      allowNull: true
    },
    Corp_Js: {
      type: DataTypes.STRING(300),
      allowNull: true
    },
    Corp_JsLXR: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    Corp_JsTel: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    Corp_Dj: {
      type: DataTypes.STRING(100),
      allowNull: true
    },
    Corp_DjLXR: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    Corp_DjTel: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    Corp_Zb: {
      type: DataTypes.STRING(300),
      allowNull: true
    },
    Corp_ZbLXR: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    Corp_ZbTel: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    Corp_dl: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    Corp_dlLXR: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    Corp_dlTel: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    CorpKind: {
      type: DataTypes.INTEGER,
      allowNull: true
    },
    ZbFlag: {
      type: DataTypes.INTEGER,
      allowNull: true
    },
    PlanCode: {
      type: DataTypes.STRING(150),
      allowNull: true
    },
    DateBidStart: {
      type: DataTypes.DATE,
      allowNull: true
    },
    DateBidEnd: {
      type: DataTypes.DATE,
      allowNull: true
    },
    Date_fb: {
      type: DataTypes.DATE,
      allowNull: true
    },
    Date_ba: {
      type: DataTypes.DATE,
      allowNull: true
    },
    ztb_registerDate: {
      type: DataTypes.DATE,
      allowNull: true
    },
    bZGYSflag: {
      type: DataTypes.INTEGER,
      allowNull: true
    },
    KeyGUID: {
      type: DataTypes.CHAR(36),
      allowNull: true
    },
    zzzgContent: {
      type: DataTypes.TEXT,
      allowNull: true
    },
    code_zbtzs0: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    code_zbtzs1: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    DatePBStart: {
      type: DataTypes.DATE,
      allowNull: true
    },
    Code_xmk: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    zbScope: {
      type: DataTypes.TEXT,
      allowNull: true
    },
    ProLibCode: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    CorpCode_dl: {
      type: DataTypes.STRING(20),
      allowNull: true
    },
    CorpCode_js: {
      type: DataTypes.STRING(20),
      allowNull: true
    },
    TENDER_PROJECT_CLASSIFY_CODE: {
      type: DataTypes.STRING(7),
      allowNull: true
    },
    PROJECT_CODE: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    TENDER_PROJECT_CODE: {
      type: DataTypes.STRING(20),
      allowNull: true
    },
    NOTICE_NATURE: {
      type: DataTypes.SMALLINT,
      allowNull: true
    },
    BULLETIN_TYPE: {
      type: DataTypes.SMALLINT,
      allowNull: true
    },
    SynRightCode: {
      type: DataTypes.INTEGER,
      allowNull: true
    },
    ZbggExchangeTime: {
      type: DataTypes.DATE,
      allowNull: true
    },
    SYNDICATED_FLAG: {
      type: DataTypes.SMALLINT,
      allowNull: true
    },
    UNIFIED_DEAL_CODE: {
      type: DataTypes.STRING(40),
      allowNull: true
    },
    PLATFORM_CODE: {
      type: DataTypes.STRING(18),
      allowNull: true
    },
    PUB_SERVICE_PLAT_CODE: {
      type: DataTypes.STRING(18),
      allowNull: true
    },
    NoticeSyncStatus: {
      type: DataTypes.SMALLINT,
      allowNull: true
    },
    PROJECT_CLASSIFY_CODE: {
      type: DataTypes.STRING(4),
      allowNull: true
    },
    ContractCode: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    IsCollectTransactionFees: {
      type: DataTypes.INTEGER,
      allowNull: true
    }
  }, {
    sequelize,
    tableName: 'zb_projectinfo',
    schema: 'dbo',
    timestamps: false
  });
};
